Add & use checkboxes

You can add checkboxes to cells in a spreadsheet. Use checkboxes for many purposes, like to track a project, take attendance, and check off your to-do list.

Insert checkboxes

1. On your computer, open a spreadsheet in Google Sheets.
2. Select the cells you want to have checkboxes.
3. In the menu at the top, click Insert Checkbox.
4. To remove checkboxes, select the checkboxes you want to remove and press Delete.

Note: You can use checkboxes with charts, filters, pivot tables, and functions.

Add custom checkbox values

You can add checkboxes with custom values. For example, the custom checked value could be "Yes," and the unchecked value could be "No."

1. On your computer, open a spreadsheet in Google Sheets.
2. Select the cells you want to have checkboxes.
3. In the menu at the top, click Data Data validation.
4. Next to "Criteria," choose Checkbox.
5. Click Use custom cell values.
6. Next to "Checked," enter a value.
7. Optional: Next to "Unchecked," enter a value.
8. Click Save.